﻿CREATE PROCEDURE [dbo].[Employee_Select]
@EmployeeID uniqueidentifier
AS
BEGIN

SELECT [EmployeeID]
, [CreatedDate]
, [CreatedBy]
, [ModifiedDate]
, [ModifiedBy]
, [Deleted]
, [DesignationID]
, [DivisionID]
, [PersonID]
, [EmployeeNumber]
FROM [dbo].[Employee] (NoLock)
WHERE [Deleted] = 0
AND [EmployeeID] = @EmployeeID


END
